
use "C:\Users\mcsam\Dropbox\Decomposing Firm Betas\Submissions\JPE Macro\Replication Folder\\Table_2_data",clear
global new_controls "ad_sales rd_sales xad xrd tnic3hhi tnic3tsimm indic_hhi indic_simm"

reg bm avg_churn sale $new_controls, vce(robust)
outreg2 using "churn_intangibles", title() keep(avg_churn) tex(landscape pr frag) drop() label addtext(Industry FE, NO, Firm Controls, YES) ctitle("B-to-M") nocons replace

reg bm avg_churn sale $new_controls, a(category_code) vce(robust)
outreg2 using "churn_intangibles", title() keep(avg_churn) tex(landscape pr frag) drop() label addtext(Industry FE, YES, Firm Controls, YES) ctitle("B-to-M") nocons 

reg ln_val_pred avg_churn sale $new_controls, vce(robust)
outreg2 using "churn_intangibles", title() keep(avg_churn) tex(landscape pr frag) drop() label addtext(Industry FE, NO, Firm Controls, YES) ctitle("ln(Brand Val)") nocons 

reg ln_val_pred avg_churn sale $new_controls, a(category_code) vce(robust)
outreg2 using "churn_intangibles", title() keep(avg_churn) tex(landscape pr frag) drop() label addtext(Industry FE, YES, Firm Controls, YES) ctitle("ln(Brand Val)") nocons 

reg lvpc avg_churn sale $new_controls, vce(robust)
outreg2 using "churn_intangibles", title() keep(avg_churn) tex(landscape pr frag) drop() label addtext(Industry FE, NO, Firm Controls, YES) ctitle("$\frac{MktValue}{Customer}$") nocons

reg lvpc avg_churn sale $new_controls, a(category_code) vce(robust)
outreg2 using "churn_intangibles", title() keep(avg_churn) tex(landscape pr frag) drop() label addtext(Industry FE, YES, Firm Controls, YES) ctitle("$\frac{MktValue}{Customer}$") nocons


